﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace Oprah
{
    class DBManager
    {
        private static string connectionString = "data source = localhost; initial catalog = Hitler; integrated security = true;";
        public string GetImage() 
        {
            string path = "";
            string strQuery = "";
            SqlConnection conn = new SqlConnection();
            SqlCommand comm;

            try
            {
                conn.ConnectionString = connectionString;
                conn.Open();

                //strQuery = "SELECT image FROM Picture p left join WHERE Username='" + username + "' AND Password='" + password + "'";
                comm = new SqlCommand(strQuery, conn);
                int count = (int)comm.ExecuteNonQuery();

                           }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                conn.Close();
            }

            return path;

        }
    }
}
